﻿CREATE FUNCTION [dbo].[fs_List_Underwrite]
(	@MenuID int
)RETURNS TABLE AS

RETURN (
SELECT     TOP (100) PERCENT fs_Base.LoanID, fs_Base.[First Name], fs_Base.[Last Name], fs_Base.[Date In],
                      fs_Base.VIN, fs_Base.Description, fs_Base.Dealer, v_TrackerRequest.TrackerRequestID
FROM         dbo.fs_List_Base(@MenuID) AS fs_Base LEFT OUTER JOIN
                      v_TrackerRequest ON fs_Base.VIN = v_TrackerRequest.VIN AND v_TrackerRequest.IsActive = 1
)





